StudentCourse 
EntityType  Independent 
Logical Entity Name  StudentCourse 
Default Table Name  AdEnrollSched 
Logical Only  NO 
Definition 
 
Note 
 

StudentCourse Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentId(FK)    INTEGER  YES 
 
ClassSectionId(FK)    INTEGER  YES 
 
TermId(FK)    INTEGER  YES 
 
AcademicYear    TINYINT  NO 
 
CourseName    VARCHAR(75)  NO 
 
StartDate    DATETIME  YES 
 
ExpectedEndDate    DATETIME  YES 
 
EndDate    DATETIME  YES 
 
LDA    DATETIME  YES 
 
GradePostedDate    DATETIME  YES 
 
DropDate    DATETIME  YES 
 
BilledDate    DATETIME  YES 
 
IsExtended    BIT  NO 
 
IsExtensionBilled    DATETIME  YES 
 
Status    CHAR(1)  NO 
 
PreviousStatus    CHAR(1)  YES 
 
Note    VARCHAR(4000)  YES 
 
TranscriptNote    VARCHAR(3000)  YES 
 
Cost    MONEY(19, 4)  NO 
 
MinutesAttended    INTEGER  NO 
 
MinutesAbsent    INTEGER  NO 
 
IsCostScheduled    BIT  NO 
 
CreditHours    NUMERIC(9, 2)  NO 
 
ClockHours    NUMERIC(9, 2)  YES 
 
NumericGrade    NUMERIC(11, 6)  YES 
 
LetterGrade    CHAR(8)  NO 
 
RetakeFlag    CHAR(1)  YES 
 
Speed    TINYINT  YES 
 
GradePoints    NUMERIC(9, 2)  NO 
 
QualityPoints    NUMERIC(9, 2)  YES 
 
CreditHoursAttempted    NUMERIC(9, 2)  NO 
 
CreditHoursEarned    NUMERIC(9, 2)  NO 
 
ClockHoursAttempted    NUMERIC(9, 2)  NO 
 
ClockHoursEarned    NUMERIC(9, 2)  NO 
 
IsIncludedInGpaCalc    BIT  NO 
 
PayStatus    CHAR(1)  YES 
 
ModFlag    CHAR(1)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentCourseId(PK)(FK)    INTEGER  NO 
 
CourseId(FK)    INTEGER  YES 
 
RequiredCourseId(FK)    INTEGER  YES 
 
CollegeId    INTEGER  YES 
 
IsSubstitute    BIT  YES 
 
SubstituteCourseId    INTEGER  YES 
 
IsTransferCredit    BIT  YES 
 
DependentClassSectionId    INTEGER  YES 
 
IsAutoDrop    BIT  NO 
 
ConsecutiveMinutesAbsent    NUMERIC(18, 0)  NO 
 
RosterFlag    CHAR(2)  YES 
 
RevenueReferenceNumber    CHAR(8)  YES 
 
RetakeOverride    BIT  NO 
 
GradeScaleId(FK)    INTEGER  YES 
 
Include    BIT  NO 
 
MakeUpMinutes    INTEGER  NO 
 
DateReqMet    DATETIME  YES 
 
TransferredCourseCode    CHAR(16)  YES 
 
TransferredCourseDescrip    VARCHAR(75)  YES 
 
AdvisedDate    DATETIME  YES 
 
IsAfterAddDrop    BIT  NO 
 
StudentTransferCreditId(FK)    INTEGER  YES 
 
IsCrossReferencedCourse    BIT  YES 
 
CrossReferenceCourseId    INTEGER  YES 
 
MidTermNumericGrade    NUMERIC(11, 6)  YES 
 
MidTermLetterGrade    CHAR(8)  YES 
 
MidTermGradeNote    VARCHAR(350)  YES 
 
MidTermGradePostedDate    DATETIME  YES 
 
IsAuditCourse    BIT  YES 
 
AuditEffectiveDate    DATETIME  YES 
 
IsPassFail    BIT  NO 
 
LmsExtractStatus    CHAR(1)  YES 
 
InProgressGrade    NUMERIC(9, 2)  YES 
 
CourseFeeScheduleId(FK)    INTEGER  YES 
 
EnrollmentStatusCreditHours    MONEY(19, 4)  NO 
 
EnrollmentStatusClockHours    MONEY(19, 4)  NO 
 
FaStudentAyPaymentPeriodId(FK)    INTEGER  YES 
 
RetakeFeeWaived    CHAR(1)  NO 
 
IsCourseRefundPolicyUsed    BIT  NO 
 
ExpectedDeadlineDate    DATETIME  YES 
 
IsIncompleteGradeReplaced    BIT  NO 
 
HighSchoolId(FK)    INTEGER  YES 
 
TransferTypeId(FK)    INTEGER  YES 
 
RetakeTiv2CredEarnZeroed    BIT  NO 
 
RetakeTiv2CredEarnValue    MONEY(19, 4)  YES 
 
IsOnlyRateScheduleUsed    BIT  YES 
 
OverrideCourseProgression    CHAR(1)  YES 
 
OutsideCourseWorkHours    NUMERIC(9, 2)  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentCourse Keys 
Key Name  Key Type  Keys 
AdEnrollSched_Status_adDependentClassSchedID_AdEnrollSchedID_U_N_IDX  Alternate Key  Status, DependentClassSectionId, StudentCourseId 
AdEnrollSched_AdEnrollID_Status_EndDate_AdCourseID_GPACalc_RetakeOverride_N_N_IDX  Inversion Entry  StudentCourseId, Status, EndDate, IsIncludedInGpaCalc, RetakeOverride 
Nk_AdEnrollSchedAmTransferTypeID  Inversion Entry  TransferTypeId 
AdEnrollSched_AdClassSchedId_Status_AfterAddDrop_N_N_idx  Inversion Entry  Id_2, Status, IsAfterAddDrop 
AdEnrollSched_AdEnrollID_AdTermID_Status_Credits_CreditsAttempt_Hours_INCLUDE_N_N_IDX  Inversion Entry  StudentCourseId, Status, CreditHours, CreditHoursAttempted, ClockHours 
AdEnrollSched_SyStudentID_StartDate_N_N_IDX  Inversion Entry  StartDate 
AdEnrollSched_AdEnrollID_Status_GPACAlc_TransferCredit_RetakeOverRide_N_N_idx  Inversion Entry  StudentCourseId, Status, IsIncludedInGpaCalc, IsTransferCredit, RetakeOverride 
NK_AdEnrollSched_AdEnrollID_Status_AdProgramCourseID_INCL  Inversion Entry  StudentCourseId, Status 
NK_AdEnrollSchedAdEnrollIDAdCourseID  Inversion Entry  StudentCourseId 
AdEnrollSched_Status_AdTermID_AdEnrollID_N_N_IDX  Inversion Entry  Status, StudentCourseId 
AdEnrollSched_AdEnrollID_AdClassSchedID_AdCourseID_N_N_IDX  Inversion Entry  StudentCourseId, Id_2 
AdEnrollSched_AmCollegeTransferID_N_N_IDX  Inversion Entry  StudentTransferCreditId 
AdEnrollSched_AdEnrollID_AdTermID_StartDate_DropDate_EndDate_ExpectedEndDate_Status_AdClassSchedID_AdEnrollSchedID_U_N_IDX  Alternate Key  StudentCourseId, StartDate, DropDate, EndDate, ExpectedEndDate, Status, Id_2 
AdEnrollSched_AdGradeLetterCode_N_N_IDX  Inversion Entry  LetterGrade 
AdEnrollSched_AdCourseID_N_N_IDX  Inversion Entry  StudentCourseId 
AdEnrollSched_RevenueRefNo_AdEnrollId_N_N_idx  Inversion Entry  RevenueReferenceNumber, StudentCourseId 
AdEnrollSched_AdEnrollSchedID_U_C_IDX  PrimaryKey  StudentCourseId 
AdEnrollSched_StartDate_SyStudentID_N_N_idx  Inversion Entry  StartDate 
AdEnrollSched_SyStudentID_AdClassSchedId_AdEnrollSchedId_U_N_IDX  Inversion Entry  Id_2, StudentCourseId 
adenrollsched_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  FaStudentAyPaymentPeriodId 
Nk_AdEnrollSchedAmHighSchoolID  Inversion Entry  HighSchoolId 
AdEnrollSched_ModFlag_N_N_IDX  Inversion Entry  ModFlag 
AdEnrollSched_SyStudentID_Status_AdCourseID_N_N_IDX  Inversion Entry  Status, StudentCourseId 
AdEnrollSched_AdClassSchedId_AdTermID_IDX  Inversion Entry  Id_2 
AdEnrollSched_AdTermID_AdEnrollSchedId_AdEnrollID_Status_SyStudentId_AdCourseId_U_N_IDX  Alternate Key  StudentCourseId, Status 

StudentCourse Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
RequiredCourse  Non-Identifying  Zero or One to Zero or More        RequiredCourseId  NO 
ClassSection  Non-Identifying  Zero or One to Zero or More        ClassSectionId  NO 
Course  Non-Identifying  Zero or One to Zero or More        CourseId  NO 
StudentTransferCredit  Non-Identifying  Zero or One to Zero or More        StudentTransferCreditId  NO 
CourseFeeSchedule  Non-Identifying  Zero or One to Zero or More        CourseFeeScheduleId  NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentCourseId  NO 
StudentCoursePendingRegistration  Non-Identifying  Zero or One to Zero or More        Id_2  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        FaStudentAyPaymentPeriodId  NO 
HighSchool  Non-Identifying  Zero or One to Zero or More        HighSchoolId  NO 
TransferCreditType  Non-Identifying  Zero or One to Zero or More        TransferTypeId  NO 
GradeScale  Non-Identifying  Zero or One to Zero or More        GradeScaleId  NO 
RequiredCourse  Non-Identifying  Zero or One to Zero or More        RequiredCourseId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentCourseStudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaTakenNotAppliedCourse  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaFulfillment  Non-Identifying  One To Zero or More          NO 
Attendance  Non-Identifying  One To Zero or More          NO 
AdAttendArchive  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaTakenNotAppliedCourse  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaFulfillment  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodLesson  Non-Identifying  One To Zero or More          NO 
StudentCourseExtension  Non-Identifying  One To Zero or More          NO 
StudentCourseStudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
StudentCourseSpeCourseCategory  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodTransferCourse  Identifying  One To Zero or More          NO 
ScheduledDisbursement  Non-Identifying  One To Zero or More          NO 
AutomaticBillingBatchDetailCourse  Identifying  One To Zero or More          NO 
StudentAccountTransactionCourse  Non-Identifying  One To Zero or More          NO 
Attendance  Non-Identifying  One To Zero or More          NO 
StudentCourseDataChange  Non-Identifying  One To Zero or More          NO 
StudentCourseExtension  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
StudentCourseStudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentDegreePathway  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaFulfillment  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentDpaTakenNotAppliedCourse  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
StudentPlacement  Non-Identifying  One To Zero or More          NO 

StudentCourse Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdEnrollSched_MinutesMakeUp  ([Hours] = 0 or [MinutesMakeUp] <= [Hours] * 60) 
Chk_AdEnrollSched_TransferredCourseCode  ([TransferredCourseCode] is null or [TransferCredit] = 1) 
Chk_AdEnrollSched_TransferredCourseDescrip  ([TransferredCourseDescrip] is null or [TransferCredit] = 1)